Видео ютуба по тегу Query On Subquery Containing Joins In Salesforce Sql (Soql)

Mastering Salesforce SQL: Fixing Subqueries with JOINS
Mastering Salesforce SQL: Fixing Subqueries with JOINS